# Imprime a data e a hora que foi compilado o arquivo
cat("Compilado em:", format(Sys.time(), "%Y-%m-%d %H:%M:%S"), "\n")Compilado em: 2025-09-30 10:55:52 Desafio 9
Importação dos Dados Iniciais
Primeiro é carregado as bibliotecas necessárias, definindo o nome do banco de dados. Logo após, as tabelas airlines e airports são peenchidas com os dados dos arquivos CSV correspondentes
library(DBI)
library(RSQLite)Warning: pacote 'RSQLite' foi compilado no R versão 4.4.3library(readr)Warning: pacote 'readr' foi compilado no R versão 4.4.3library(dplyr)
Anexando pacote: 'dplyr'Os seguintes objetos são mascarados por 'package:stats':
filter, lagOs seguintes objetos são mascarados por 'package:base':
intersect, setdiff, setequal, uniondb_file <- "voos.sqlite3"
# Cria uma conexão com o banco de dados SQLite
con <- dbConnect(RSQLite::SQLite(), db_file)
# Lê os arquivos CSV e os escreve nas tabelas do banco de dados
# O argumento 'overwrite = TRUE' garante que a tabela seja recriada se já existir
dbWriteTable(con, "airlines", read_csv("airlines.csv"), overwrite = TRUE)Rows: 14 Columns: 2
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (2): IATA_CODE, AIRLINE
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.dbWriteTable(con, "airports", read_csv("airports.csv"), overwrite = TRUE)Rows: 322 Columns: 7
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (5): IATA_CODE, AIRPORT, CITY, STATE, COUNTRY
dbl (2): LATITUDE, LONGITUDE
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.Filtrando e Carregando os Dados de Voos
O arquivo flights.csv é muito grande, por isso é usada uma função (lerDados) que processa o arquivo em “pedaços”. A função filtra os voos de interesse e os adiciona à tabela flights no banco de dados.
# Define os aeroportos de interesse para o filtro
aeroportos_interesse <- c("BWI", "MIA", "SEA", "SFO", "JFK")
# Função para processar cada lote de dados, conforme solicitado
lerDados <- function(input, pos) {
# Exibe uma mensagem de progresso no console
message("Processando a partir da linha ", pos)
# Filtra as linhas onde a origem ou o destino estão na lista de interesse.
voos_filtrados <- subset(input, ORIGIN_AIRPORT %in% aeroportos_interesse | DESTINATION_AIRPORT %in% aeroportos_interesse)
# Adiciona os dados filtrados à tabela 'flights' no banco
# 'append = TRUE' : dados de cada lote são adicionados sem apagar os anteriores
dbWriteTable(con, "flights", voos_filtrados, append = TRUE)
}
# Lê o arquivo 'flights.csv' em lotes, aplicando a função 'lerDados'
read_csv_chunked(
"flights.csv",
callback = SideEffectChunkCallback$new(lerDados),
chunk_size = 100000,
# Usei o col_types para selecionar as colunas de forma compatível com qualquer versão do readr, pois o col_select não estava funcionando
col_types = cols(
YEAR = col_integer(),
MONTH = col_integer(),
DAY = col_integer(),
AIRLINE = col_character(),
FLIGHT_NUMBER = col_integer(),
ORIGIN_AIRPORT = col_character(),
DESTINATION_AIRPORT = col_character(),
ARRIVAL_DELAY = col_double(),
.default = col_skip() # Pula todas as colunas não especificadas
)
)Processando a partir da linha 1Processando a partir da linha 100001Processando a partir da linha 200001Processando a partir da linha 300001Processando a partir da linha 400001Processando a partir da linha 500001Processando a partir da linha 600001Processando a partir da linha 700001Processando a partir da linha 800001Processando a partir da linha 900001Processando a partir da linha 1000001Processando a partir da linha 1100001Processando a partir da linha 1200001Processando a partir da linha 1300001Processando a partir da linha 1400001Processando a partir da linha 1500001Processando a partir da linha 1600001Processando a partir da linha 1700001Processando a partir da linha 1800001Processando a partir da linha 1900001Processando a partir da linha 2000001Processando a partir da linha 2100001Processando a partir da linha 2200001Processando a partir da linha 2300001Processando a partir da linha 2400001Processando a partir da linha 2500001Processando a partir da linha 2600001Processando a partir da linha 2700001Processando a partir da linha 2800001Processando a partir da linha 2900001Processando a partir da linha 3000001Processando a partir da linha 3100001Processando a partir da linha 3200001Processando a partir da linha 3300001Processando a partir da linha 3400001Processando a partir da linha 3500001Processando a partir da linha 3600001Processando a partir da linha 3700001Processando a partir da linha 3800001Processando a partir da linha 3900001Processando a partir da linha 4000001Processando a partir da linha 4100001Processando a partir da linha 4200001Processando a partir da linha 4300001Processando a partir da linha 4400001Processando a partir da linha 4500001Processando a partir da linha 4600001Processando a partir da linha 4700001Processando a partir da linha 4800001Processando a partir da linha 4900001Processando a partir da linha 5000001Processando a partir da linha 5100001Processando a partir da linha 5200001Processando a partir da linha 5300001Processando a partir da linha 5400001Processando a partir da linha 5500001Processando a partir da linha 5600001Processando a partir da linha 5700001Processando a partir da linha 5800001NULLmessage("Processamento em lotes concluído!")Processamento em lotes concluído!Consulta e Análise Final
Com todos os dados de voos relevantes no banco, uma consulta SQL é executada para calcular o tempo médio de atraso na chegada para cada aeroporto, juntando as informações das tabelas para obter os nomes completos dos aeroportos e das companhias aéreas
# Define a consulta SQL para a análise
query <- "
SELECT
AVG(f.ARRIVAL_DELAY) AS atraso_medio,
a.IATA_CODE AS sigla_aeroporto,
a.AIRPORT AS nome_aeroporto,
al.AIRLINE AS nome_companhia
FROM
flights f
JOIN
airports a ON f.DESTINATION_AIRPORT = a.IATA_CODE
JOIN
airlines al ON f.AIRLINE = al.IATA_CODE
GROUP BY
a.IATA_CODE, a.AIRPORT, al.AIRLINE
ORDER BY
atraso_medio DESC
"
resultado_final <- dbGetQuery(con, query)
resultado_final atraso_medio sigla_aeroporto
1 143.00000000 DTW
2 41.00000000 JAX
3 36.20000000 IAH
4 34.50000000 MSN
5 27.71428571 IAH
6 25.79268293 ATL
7 24.02068966 LGA
8 22.45724907 ORD
9 22.44827586 MTJ
10 22.17613636 MSP
11 22.00000000 BNA
12 20.62068966 MSO
13 19.11235955 ATL
14 19.09426987 ORD
15 19.02762431 JAC
16 18.49951737 DEN
17 18.08219178 DCA
18 17.83263598 OTH
19 17.27627628 IAH
20 17.09623431 IAH
21 17.01772152 BWI
22 16.95054945 ASE
23 16.94848485 LAS
24 16.68000000 RIC
25 16.39325843 MIA
26 16.35460993 LAX
27 16.35398230 KTN
28 15.84313725 JNU
29 15.26947891 MIA
30 15.04894384 SFO
31 15.02409639 STL
32 14.86992716 HNL
33 14.85572139 MYR
34 14.80511182 PHL
35 14.78358209 TUS
36 14.77358491 PHX
37 14.72965703 HNL
38 14.56451613 HDN
39 14.35451505 STL
40 14.34477379 CLT
41 14.32851986 PDX
42 14.20797931 BOS
43 13.99559471 EGE
44 13.74077253 STT
45 13.56886228 ATL
46 13.49808429 SAT
47 13.44375963 FLL
48 13.36585366 IAD
49 13.21359223 LAX
50 13.09536785 ORD
51 13.02173913 DFW
52 12.91133005 MCI
53 12.87552644 BDL
54 12.79076923 PSE
55 12.68750000 ATL
56 12.60509554 BUF
57 12.39646465 MSP
58 12.35886020 ORF
59 12.15687790 EWR
60 12.06749740 PBI
61 11.85637222 ISP
62 11.83349950 IND
63 11.79889469 JFK
64 11.72777778 ANC
65 11.71153846 ECP
66 11.64723926 OKC
67 11.51623377 MSY
68 11.43088235 JFK
69 11.41304348 TUL
70 11.35663338 ROC
71 11.22593431 BUF
72 11.14848485 DFW
73 11.04179409 SYR
74 10.88936627 ORD
75 10.86461056 RDU
76 10.84513399 FLL
77 10.76315789 STL
78 10.76033058 LAS
79 10.74213836 ANC
80 10.40128558 JAX
81 10.39814815 BOS
82 10.34238311 AUS
83 10.33875339 BDL
84 10.32306684 SJU
85 10.27891156 BQN
86 10.26279863 JFK
87 10.17465389 JAX
88 10.09068449 SFO
89 10.02305159 IAD
90 9.84973638 SMF
91 9.83443709 SUN
92 9.77543860 LAX
93 9.70954357 PBI
94 9.67561168 ACV
95 9.66469894 SJC
96 9.65256798 OGG
97 9.64659843 ALB
98 9.63306452 CHS
99 9.62626263 SEA
100 9.60670732 DAL
101 9.57939914 EWR
102 9.56047560 PVD
103 9.53431890 PIT
104 9.31818182 LIT
105 9.25000000 JAC
106 9.13486513 CHS
107 9.13148148 MHT
108 9.08437500 OGG
109 9.07142857 FLL
110 9.03088803 RDU
111 9.02810785 SFO
112 9.02689873 GRR
113 8.98250000 AUS
114 8.96578947 LGA
115 8.89286690 MCO
116 8.82258065 PDX
117 8.75854082 FAT
118 8.73804574 PNS
119 8.71755725 MMH
120 8.67832168 GNV
121 8.67523124 PWM
122 8.65387894 CLE
123 8.64418159 MIA
124 8.52480916 FNT
125 8.44175317 SAN
126 8.24761905 DEN
127 8.20558882 DCA
128 8.19090909 MCI
129 8.18061367 RNO
130 8.17647059 RNO
131 8.12184116 OAK
132 8.07507508 PHX
133 8.07145067 DCA
134 7.99698795 ABQ
135 7.97597598 COS
136 7.95451264 CMH
137 7.91600000 BTV
138 7.91324921 PSP
139 7.90791599 AUS
140 7.90715733 BWI
141 7.84284284 MCO
142 7.79687500 MSP
143 7.79238095 PSC
144 7.78904250 BNA
145 7.77836691 SLC
146 7.71926489 SNA
147 7.65532544 DAY
148 7.59459459 RSW
149 7.57277883 AUS
150 7.56940510 RDD
151 7.56682028 JFK
152 7.44944321 BUF
153 7.40161290 SJU
154 7.39619651 MFR
155 7.38983051 PDX
156 7.36161903 BOS
157 7.30492424 OGG
158 7.16113744 PSP
159 7.14752568 ROC
160 7.13307331 SEA
161 7.12447257 AUS
162 7.11519045 SJU
163 7.11261261 LGA
164 7.05074462 EUG
165 7.03361669 MIA
166 6.99170813 RSW
167 6.84588872 BWI
168 6.83707865 STX
169 6.82375237 FLL
170 6.81821500 LAX
171 6.81670886 TPA
172 6.80194018 BOS
173 6.74631829 SEA
174 6.72847409 SFO
175 6.69095477 BOI
176 6.68027211 BZN
177 6.65483871 ANC
178 6.60716014 SMF
179 6.60000000 MCO
180 6.56680162 BLI
181 6.50930969 SFO
182 6.48438031 LAX
183 6.47169811 DFW
184 6.46107784 OMA
185 6.40617284 RDM
186 6.39675676 DTW
187 6.37091189 LAS
188 6.36297180 IAH
189 6.34150613 PWM
190 6.27676484 TPA
191 6.26679104 BHM
192 6.26367626 MIA
193 6.18389662 RDU
194 6.08436887 GEG
195 6.05378931 SEA
196 5.96402878 IND
197 5.95045045 SEA
198 5.94037589 BUR
199 5.91860465 MCI
200 5.91369048 ORF
201 5.91176471 CHS
202 5.91114768 ATL
203 5.91007562 DEN
204 5.90718563 BWI
205 5.90017690 SAN
206 5.88737934 LAX
207 5.84955752 LAS
208 5.81727488 JFK
209 5.78396947 LAS
210 5.76125010 JFK
211 5.76037196 TPA
212 5.74166667 OKC
213 5.64096774 MCO
214 5.59589041 GSO
215 5.56250000 MSP
216 5.54737336 PDX
217 5.53579060 BWI
218 5.49591352 DFW
219 5.47616312 DAL
220 5.36708861 SDF
221 5.35152420 SFO
222 5.33289817 PDX
223 5.30458221 CMH
224 5.27965180 AUS
225 5.26633479 STL
226 5.21035599 DEN
227 5.18482816 ORD
228 5.17592593 DCA
229 5.10000000 GSP
230 5.09142857 BNA
231 5.08984615 IAH
232 5.06871345 PHX
233 5.01597444 IND
234 4.99340245 BWI
235 4.97641509 MSY
236 4.94898551 SAN
237 4.93057410 HNL
238 4.90469974 ORD
239 4.89779006 SAN
240 4.89520958 HOU
241 4.87500000 DTW
242 4.83419689 BHM
243 4.79166667 LIH
244 4.73755378 GEG
245 4.71918187 JFK
246 4.68474404 PDX
247 4.67819149 MRY
248 4.62435233 SLC
249 4.59287257 SEA
250 4.56756757 HOU
251 4.50232558 SJC
252 4.48339483 ABQ
253 4.40797546 JAX
254 4.40381268 SFO
255 4.39037433 IAD
256 4.37653157 SEA
257 4.31791908 SLC
258 4.30955414 MCO
259 4.28111156 SBA
260 4.28000000 CEC
261 4.27743902 SAV
262 4.27364017 KTN
263 4.25710419 PHL
264 4.22429907 EYW
265 4.21653543 SBP
266 4.20144462 ONT
267 4.19338422 SAT
268 4.18926554 MIA
269 4.16479401 CLE
270 4.15843023 KOA
271 4.06905917 SFO
272 4.05724824 EWR
273 4.01304945 PHL
274 4.00000000 OKC
275 3.99228928 DEN
276 3.98019802 LAS
277 3.97272727 ACK
278 3.93540373 PHX
279 3.90444444 CVG
280 3.87311412 SFO
281 3.86330935 JNU
282 3.84089219 PSP
283 3.83140878 BWI
284 3.78516129 PHX
285 3.74437086 DEN
286 3.71980676 SAT
287 3.70397644 AUS
288 3.67494357 CLE
289 3.63685932 LAS
290 3.55555556 HYA
291 3.50561798 ATL
292 3.50312650 BOS
293 3.44887781 MKE
294 3.44215938 MSY
295 3.42947311 MDW
296 3.39336918 JNU
297 3.39084358 LGB
298 3.37037037 FAI
299 3.33638083 SEA
300 3.33465459 SMF
301 3.25437202 PHL
302 3.19139466 FLL
303 3.18511066 DEN
304 3.14285714 SIT
305 3.07750678 SAN
306 3.06079027 SLC
307 3.04687500 RDU
308 2.98709059 BWI
309 2.95130774 ORD
310 2.81556257 SLC
311 2.81337047 JFK
312 2.79239766 PDX
313 2.63450502 PHX
314 2.61721068 BUR
315 2.56325823 ABQ
316 2.54474097 CLT
317 2.47258486 MEM
318 2.43793503 PHX
319 2.33363229 ORD
320 2.22605721 SFO
321 2.15050167 SJC
322 2.11895593 LAX
323 2.09489051 SIT
324 2.08390163 CLT
325 2.03046127 SNA
326 2.00000000 LAS
327 1.90969900 EWR
328 1.89887640 RDU
329 1.81453634 STL
330 1.77209945 SNA
331 1.61550388 BFL
332 1.60000000 MSY
333 1.59571136 LAX
334 1.59359606 SMX
335 1.54707792 OAK
336 1.50000000 LGB
337 1.32208029 TPA
338 1.30921053 DTW
339 1.30696366 SEA
340 1.30357143 RNO
341 1.25319343 SAN
342 1.20952381 TLH
343 1.20000000 DTW
344 1.17744610 DTW
345 0.96882952 SEA
346 0.89709763 IAH
347 0.87481061 CLT
348 0.83750000 SLC
349 0.74840085 FLL
350 0.72493888 MSY
351 0.61000000 OAK
352 0.54060914 MCI
353 0.52994012 SAT
354 0.51720183 PHX
355 0.47682119 DFW
356 0.42105263 PBI
357 0.37775977 ANC
358 0.26172466 SFO
359 0.13312303 DEN
360 0.11900192 ONT
361 0.07654921 IAD
362 0.06553485 MIA
363 0.03790151 ATL
364 0.00000000 PBI
365 -0.09857724 LAS
366 -0.18918919 IAD
367 -0.22904769 BWI
368 -0.37048193 PHL
369 -0.44116734 PHX
370 -0.46587031 MSP
371 -0.51051051 FLL
372 -0.51254480 SMF
373 -0.52972417 MSP
374 -0.70278271 LAS
375 -0.81756757 MEM
376 -0.93832021 SAN
377 -0.96352584 SRQ
378 -0.98784195 BUR
379 -1.00000000 OKC
380 -1.00932401 ATL
381 -1.01649953 SEA
382 -1.07975460 EWR
383 -1.08645533 TUS
384 -1.31715006 SJU
385 -1.73117822 SNA
386 -1.76973684 MKE
387 -1.90196078 MSY
388 -1.94367589 SLC
389 -2.00000000 SJC
390 -2.01333333 ORD
391 -2.04166667 CVG
392 -2.05066445 FAI
393 -2.21556886 DTW
394 -2.53164557 PIT
395 -2.54716981 BOS
396 -2.83471074 MVY
397 -2.84666667 CLE
398 -2.89473684 MCI
399 -2.90491803 STT
400 -3.00000000 CVG
401 -3.10638298 ORD
402 -3.27450980 XNA
403 -3.33082707 PIT
404 -3.53541417 HNL
405 -3.55000000 HNL
406 -3.56643357 CHS
407 -3.64516129 OAK
408 -3.73654391 LAX
409 -3.77639752 RSW
410 -3.82800609 DCA
411 -3.89696970 PSP
412 -3.93373494 DCA
413 -3.97991968 BOS
414 -4.01449275 BNA
415 -4.50000000 TPA
416 -4.52807018 KOA
417 -4.60173913 AUS
418 -4.92469880 MSY
419 -5.00000000 BWI
420 -5.29623568 SAN
421 -5.40000000 DCA
422 -5.51295337 OGG
423 -6.00000000 GSP
424 -6.76923077 KOA
425 -7.03448276 OGG
426 -7.03791469 MCO
427 -7.93712575 TPA
428 -8.01075269 SAT
429 -8.25287356 SAT
430 -8.53846154 BIL
431 -8.87169811 IAD
432 -9.00000000 SMF
433 -10.00000000 JAC
434 -10.64734300 BWI
435 -10.73960217 LIH
436 -12.50000000 IAH
437 -13.00000000 BOI
438 -13.60000000 RDU
439 -14.60000000 ORD
440 -14.86885246 RDU
441 -15.75000000 JFK
442 -16.00000000 SYR
443 -17.00000000 OMA
444 -17.38922156 ABQ
445 -18.69230769 CHS
446 -19.00000000 MSP
447 -32.00000000 CLE
448 -35.00000000 SAV
nome_aeroporto
1 Detroit Metropolitan Airport
2 Jacksonville International Airport
3 George Bush Intercontinental Airport
4 Dane County Regional Airport
5 George Bush Intercontinental Airport
6 Hartsfield-Jackson Atlanta International Airport
7 LaGuardia Airport (Marine Air Terminal)
8 Chicago O'Hare International Airport
9 Montrose Regional Airport
10 Minneapolis-Saint Paul International Airport
11 Nashville International Airport
12 Missoula International Airport
13 Hartsfield-Jackson Atlanta International Airport
14 Chicago O'Hare International Airport
15 Jackson Hole Airport
16 Denver International Airport
17 Ronald Reagan Washington National Airport
18 Southwest Oregon Regional Airport (North Bend Municipal)
19 George Bush Intercontinental Airport
20 George Bush Intercontinental Airport
21 Baltimore-Washington International Airport
22 Aspen-Pitkin County Airport
23 McCarran International Airport
24 Richmond International Airport
25 Miami International Airport
26 Los Angeles International Airport
27 Ketchikan International Airport
28 Juneau International Airport
29 Miami International Airport
30 San Francisco International Airport
31 St. Louis International Airport at Lambert Field
32 Honolulu International Airport
33 Myrtle Beach International Airport
34 Philadelphia International Airport
35 Tucson International Airport
36 Phoenix Sky Harbor International Airport
37 Honolulu International Airport
38 Yampa Valley Airport (Yampa Valley Regional)
39 St. Louis International Airport at Lambert Field
40 Charlotte Douglas International Airport
41 Portland International Airport
42 Gen. Edward Lawrence Logan International Airport
43 Eagle County Regional Airport
44 Cyril E. King Airport
45 Hartsfield-Jackson Atlanta International Airport
46 San Antonio International Airport
47 Fort Lauderdale-Hollywood International Airport
48 Washington Dulles International Airport
49 Los Angeles International Airport
50 Chicago O'Hare International Airport
51 Dallas/Fort Worth International Airport
52 Kansas City International Airport
53 Bradley International Airport
54 Mercedita Airport
55 Hartsfield-Jackson Atlanta International Airport
56 Buffalo Niagara International Airport
57 Minneapolis-Saint Paul International Airport
58 Norfolk International Airport
59 Newark Liberty International Airport
60 Palm Beach International Airport
61 Long Island MacArthur Airport
62 Indianapolis International Airport
63 John F. Kennedy International Airport (New York International Airport)
64 Ted Stevens Anchorage International Airport
65 Northwest Florida Beaches International Airport
66 Will Rogers World Airport
67 Louis Armstrong New Orleans International Airport
68 John F. Kennedy International Airport (New York International Airport)
69 Tulsa International Airport
70 Greater Rochester International Airport
71 Buffalo Niagara International Airport
72 Dallas/Fort Worth International Airport
73 Syracuse Hancock International Airport
74 Chicago O'Hare International Airport
75 Raleigh-Durham International Airport
76 Fort Lauderdale-Hollywood International Airport
77 St. Louis International Airport at Lambert Field
78 McCarran International Airport
79 Ted Stevens Anchorage International Airport
80 Jacksonville International Airport
81 Gen. Edward Lawrence Logan International Airport
82 Austin-Bergstrom International Airport
83 Bradley International Airport
84 Luis Muñoz Marín International Airport
85 Rafael Hernández Airport
86 John F. Kennedy International Airport (New York International Airport)
87 Jacksonville International Airport
88 San Francisco International Airport
89 Washington Dulles International Airport
90 Sacramento International Airport
91 Friedman Memorial Airport
92 Los Angeles International Airport
93 Palm Beach International Airport
94 Arcata Airport
95 Norman Y. Mineta San José International Airport
96 Kahului Airport
97 Albany International Airport
98 Charleston International Airport/Charleston AFB
99 Seattle-Tacoma International Airport
100 Dallas Love Field
101 Newark Liberty International Airport
102 Theodore Francis Green State Airport
103 Pittsburgh International Airport
104 Bill and Hillary Clinton National Airport (Adams Field)
105 Jackson Hole Airport
106 Charleston International Airport/Charleston AFB
107 Manchester-Boston Regional Airport
108 Kahului Airport
109 Fort Lauderdale-Hollywood International Airport
110 Raleigh-Durham International Airport
111 San Francisco International Airport
112 Gerald R. Ford International Airport
113 Austin-Bergstrom International Airport
114 LaGuardia Airport (Marine Air Terminal)
115 Orlando International Airport
116 Portland International Airport
117 Fresno Yosemite International Airport
118 Pensacola International Airport (Pensacola Gulf Coast Regional Airport)
119 Mammoth Yosemite Airport
120 Gainesville Regional Airport
121 Portland International Jetport
122 Cleveland Hopkins International Airport
123 Miami International Airport
124 Bishop International Airport
125 San Diego International Airport (Lindbergh Field)
126 Denver International Airport
127 Ronald Reagan Washington National Airport
128 Kansas City International Airport
129 Reno/Tahoe International Airport
130 Reno/Tahoe International Airport
131 Oakland International Airport
132 Phoenix Sky Harbor International Airport
133 Ronald Reagan Washington National Airport
134 Albuquerque International Sunport
135 City of Colorado Springs Municipal Airport
136 Port Columbus International Airport
137 Burlington International Airport
138 Palm Springs International Airport
139 Austin-Bergstrom International Airport
140 Baltimore-Washington International Airport
141 Orlando International Airport
142 Minneapolis-Saint Paul International Airport
143 Tri-Cities Airport
144 Nashville International Airport
145 Salt Lake City International Airport
146 John Wayne Airport (Orange County Airport)
147 James M. Cox Dayton International Airport
148 Southwest Florida International Airport
149 Austin-Bergstrom International Airport
150 Redding Municipal Airport
151 John F. Kennedy International Airport (New York International Airport)
152 Buffalo Niagara International Airport
153 Luis Muñoz Marín International Airport
154 Rogue Valley International Airport
155 Portland International Airport
156 Gen. Edward Lawrence Logan International Airport
157 Kahului Airport
158 Palm Springs International Airport
159 Greater Rochester International Airport
160 Seattle-Tacoma International Airport
161 Austin-Bergstrom International Airport
162 Luis Muñoz Marín International Airport
163 LaGuardia Airport (Marine Air Terminal)
164 Eugene Airport (Mahlon Sweet Field)
165 Miami International Airport
166 Southwest Florida International Airport
167 Baltimore-Washington International Airport
168 Henry E. Rohlsen Airport
169 Fort Lauderdale-Hollywood International Airport
170 Los Angeles International Airport
171 Tampa International Airport
172 Gen. Edward Lawrence Logan International Airport
173 Seattle-Tacoma International Airport
174 San Francisco International Airport
175 Boise Airport (Boise Air Terminal)
176 Bozeman Yellowstone International Airport (Gallatin Field Airport)
177 Ted Stevens Anchorage International Airport
178 Sacramento International Airport
179 Orlando International Airport
180 Bellingham International Airport
181 San Francisco International Airport
182 Los Angeles International Airport
183 Dallas/Fort Worth International Airport
184 Eppley Airfield
185 Redmond Municipal Airport (Roberts Field)
186 Detroit Metropolitan Airport
187 McCarran International Airport
188 George Bush Intercontinental Airport
189 Portland International Jetport
190 Tampa International Airport
191 Birmingham-Shuttlesworth International Airport
192 Miami International Airport
193 Raleigh-Durham International Airport
194 Spokane International Airport
195 Seattle-Tacoma International Airport
196 Indianapolis International Airport
197 Seattle-Tacoma International Airport
198 Bob Hope Airport (Hollywood Burbank Airport)
199 Kansas City International Airport
200 Norfolk International Airport
201 Charleston International Airport/Charleston AFB
202 Hartsfield-Jackson Atlanta International Airport
203 Denver International Airport
204 Baltimore-Washington International Airport
205 San Diego International Airport (Lindbergh Field)
206 Los Angeles International Airport
207 McCarran International Airport
208 John F. Kennedy International Airport (New York International Airport)
209 McCarran International Airport
210 John F. Kennedy International Airport (New York International Airport)
211 Tampa International Airport
212 Will Rogers World Airport
213 Orlando International Airport
214 Piedmont Triad International Airport
215 Minneapolis-Saint Paul International Airport
216 Portland International Airport
217 Baltimore-Washington International Airport
218 Dallas/Fort Worth International Airport
219 Dallas Love Field
220 Louisville International Airport (Standiford Field)
221 San Francisco International Airport
222 Portland International Airport
223 Port Columbus International Airport
224 Austin-Bergstrom International Airport
225 St. Louis International Airport at Lambert Field
226 Denver International Airport
227 Chicago O'Hare International Airport
228 Ronald Reagan Washington National Airport
229 Greenville-Spartanburg International Airport
230 Nashville International Airport
231 George Bush Intercontinental Airport
232 Phoenix Sky Harbor International Airport
233 Indianapolis International Airport
234 Baltimore-Washington International Airport
235 Louis Armstrong New Orleans International Airport
236 San Diego International Airport (Lindbergh Field)
237 Honolulu International Airport
238 Chicago O'Hare International Airport
239 San Diego International Airport (Lindbergh Field)
240 William P. Hobby Airport
241 Detroit Metropolitan Airport
242 Birmingham-Shuttlesworth International Airport
243 Lihue Airport
244 Spokane International Airport
245 John F. Kennedy International Airport (New York International Airport)
246 Portland International Airport
247 Monterey Regional Airport (Monterey Peninsula Airport)
248 Salt Lake City International Airport
249 Seattle-Tacoma International Airport
250 William P. Hobby Airport
251 Norman Y. Mineta San José International Airport
252 Albuquerque International Sunport
253 Jacksonville International Airport
254 San Francisco International Airport
255 Washington Dulles International Airport
256 Seattle-Tacoma International Airport
257 Salt Lake City International Airport
258 Orlando International Airport
259 Santa Barbara Municipal Airport (Santa Barbara Airport)
260 Del Norte County Airport (Jack McNamara Field)
261 Savannah/Hilton Head International Airport
262 Ketchikan International Airport
263 Philadelphia International Airport
264 Key West International Airport
265 San Luis Obispo County Regional Airport (McChesney Field)
266 Ontario International Airport
267 San Antonio International Airport
268 Miami International Airport
269 Cleveland Hopkins International Airport
270 Kona International Airport at Keahole
271 San Francisco International Airport
272 Newark Liberty International Airport
273 Philadelphia International Airport
274 Will Rogers World Airport
275 Denver International Airport
276 McCarran International Airport
277 Nantucket Memorial Airport
278 Phoenix Sky Harbor International Airport
279 Cincinnati/Northern Kentucky International Airport
280 San Francisco International Airport
281 Juneau International Airport
282 Palm Springs International Airport
283 Baltimore-Washington International Airport
284 Phoenix Sky Harbor International Airport
285 Denver International Airport
286 San Antonio International Airport
287 Austin-Bergstrom International Airport
288 Cleveland Hopkins International Airport
289 McCarran International Airport
290 Barnstable Municipal Airport
291 Hartsfield-Jackson Atlanta International Airport
292 Gen. Edward Lawrence Logan International Airport
293 General Mitchell International Airport
294 Louis Armstrong New Orleans International Airport
295 Chicago Midway International Airport
296 Juneau International Airport
297 Long Beach Airport (Daugherty Field)
298 Fairbanks International Airport
299 Seattle-Tacoma International Airport
300 Sacramento International Airport
301 Philadelphia International Airport
302 Fort Lauderdale-Hollywood International Airport
303 Denver International Airport
304 Sitka Rocky Gutierrez Airport
305 San Diego International Airport (Lindbergh Field)
306 Salt Lake City International Airport
307 Raleigh-Durham International Airport
308 Baltimore-Washington International Airport
309 Chicago O'Hare International Airport
310 Salt Lake City International Airport
311 John F. Kennedy International Airport (New York International Airport)
312 Portland International Airport
313 Phoenix Sky Harbor International Airport
314 Bob Hope Airport (Hollywood Burbank Airport)
315 Albuquerque International Sunport
316 Charlotte Douglas International Airport
317 Memphis International Airport
318 Phoenix Sky Harbor International Airport
319 Chicago O'Hare International Airport
320 San Francisco International Airport
321 Norman Y. Mineta San José International Airport
322 Los Angeles International Airport
323 Sitka Rocky Gutierrez Airport
324 Charlotte Douglas International Airport
325 John Wayne Airport (Orange County Airport)
326 McCarran International Airport
327 Newark Liberty International Airport
328 Raleigh-Durham International Airport
329 St. Louis International Airport at Lambert Field
330 John Wayne Airport (Orange County Airport)
331 Meadows Field
332 Louis Armstrong New Orleans International Airport
333 Los Angeles International Airport
334 Santa Maria Public Airport (Capt G. Allan Hancock Field)
335 Oakland International Airport
336 Long Beach Airport (Daugherty Field)
337 Tampa International Airport
338 Detroit Metropolitan Airport
339 Seattle-Tacoma International Airport
340 Reno/Tahoe International Airport
341 San Diego International Airport (Lindbergh Field)
342 Tallahassee International Airport
343 Detroit Metropolitan Airport
344 Detroit Metropolitan Airport
345 Seattle-Tacoma International Airport
346 George Bush Intercontinental Airport
347 Charlotte Douglas International Airport
348 Salt Lake City International Airport
349 Fort Lauderdale-Hollywood International Airport
350 Louis Armstrong New Orleans International Airport
351 Oakland International Airport
352 Kansas City International Airport
353 San Antonio International Airport
354 Phoenix Sky Harbor International Airport
355 Dallas/Fort Worth International Airport
356 Palm Beach International Airport
357 Ted Stevens Anchorage International Airport
358 San Francisco International Airport
359 Denver International Airport
360 Ontario International Airport
361 Washington Dulles International Airport
362 Miami International Airport
363 Hartsfield-Jackson Atlanta International Airport
364 Palm Beach International Airport
365 McCarran International Airport
366 Washington Dulles International Airport
367 Baltimore-Washington International Airport
368 Philadelphia International Airport
369 Phoenix Sky Harbor International Airport
370 Minneapolis-Saint Paul International Airport
371 Fort Lauderdale-Hollywood International Airport
372 Sacramento International Airport
373 Minneapolis-Saint Paul International Airport
374 McCarran International Airport
375 Memphis International Airport
376 San Diego International Airport (Lindbergh Field)
377 Sarasota-Bradenton International Airport
378 Bob Hope Airport (Hollywood Burbank Airport)
379 Will Rogers World Airport
380 Hartsfield-Jackson Atlanta International Airport
381 Seattle-Tacoma International Airport
382 Newark Liberty International Airport
383 Tucson International Airport
384 Luis Muñoz Marín International Airport
385 John Wayne Airport (Orange County Airport)
386 General Mitchell International Airport
387 Louis Armstrong New Orleans International Airport
388 Salt Lake City International Airport
389 Norman Y. Mineta San José International Airport
390 Chicago O'Hare International Airport
391 Cincinnati/Northern Kentucky International Airport
392 Fairbanks International Airport
393 Detroit Metropolitan Airport
394 Pittsburgh International Airport
395 Gen. Edward Lawrence Logan International Airport
396 Martha's Vineyard Airport
397 Cleveland Hopkins International Airport
398 Kansas City International Airport
399 Cyril E. King Airport
400 Cincinnati/Northern Kentucky International Airport
401 Chicago O'Hare International Airport
402 Northwest Arkansas Regional Airport
403 Pittsburgh International Airport
404 Honolulu International Airport
405 Honolulu International Airport
406 Charleston International Airport/Charleston AFB
407 Oakland International Airport
408 Los Angeles International Airport
409 Southwest Florida International Airport
410 Ronald Reagan Washington National Airport
411 Palm Springs International Airport
412 Ronald Reagan Washington National Airport
413 Gen. Edward Lawrence Logan International Airport
414 Nashville International Airport
415 Tampa International Airport
416 Kona International Airport at Keahole
417 Austin-Bergstrom International Airport
418 Louis Armstrong New Orleans International Airport
419 Baltimore-Washington International Airport
420 San Diego International Airport (Lindbergh Field)
421 Ronald Reagan Washington National Airport
422 Kahului Airport
423 Greenville-Spartanburg International Airport
424 Kona International Airport at Keahole
425 Kahului Airport
426 Orlando International Airport
427 Tampa International Airport
428 San Antonio International Airport
429 San Antonio International Airport
430 Billings Logan International Airport
431 Washington Dulles International Airport
432 Sacramento International Airport
433 Jackson Hole Airport
434 Baltimore-Washington International Airport
435 Lihue Airport
436 George Bush Intercontinental Airport
437 Boise Airport (Boise Air Terminal)
438 Raleigh-Durham International Airport
439 Chicago O'Hare International Airport
440 Raleigh-Durham International Airport
441 John F. Kennedy International Airport (New York International Airport)
442 Syracuse Hancock International Airport
443 Eppley Airfield
444 Albuquerque International Sunport
445 Charleston International Airport/Charleston AFB
446 Minneapolis-Saint Paul International Airport
447 Cleveland Hopkins International Airport
448 Savannah/Hilton Head International Airport
nome_companhia
1 Skywest Airlines Inc.
2 Delta Air Lines Inc.
3 US Airways Inc.
4 United Air Lines Inc.
5 Skywest Airlines Inc.
6 Spirit Air Lines
7 Frontier Airlines Inc.
8 Spirit Air Lines
9 Skywest Airlines Inc.
10 Spirit Air Lines
11 American Airlines Inc.
12 Skywest Airlines Inc.
13 Frontier Airlines Inc.
14 Frontier Airlines Inc.
15 Skywest Airlines Inc.
16 Frontier Airlines Inc.
17 Delta Air Lines Inc.
18 Skywest Airlines Inc.
19 Frontier Airlines Inc.
20 Spirit Air Lines
21 Spirit Air Lines
22 Skywest Airlines Inc.
23 Spirit Air Lines
24 American Eagle Airlines Inc.
25 Skywest Airlines Inc.
26 Spirit Air Lines
27 Skywest Airlines Inc.
28 Skywest Airlines Inc.
29 Frontier Airlines Inc.
30 Frontier Airlines Inc.
31 United Air Lines Inc.
32 Hawaiian Airlines Inc.
33 Spirit Air Lines
34 Frontier Airlines Inc.
35 Skywest Airlines Inc.
36 Frontier Airlines Inc.
37 United Air Lines Inc.
38 Skywest Airlines Inc.
39 American Airlines Inc.
40 Southwest Airlines Co.
41 JetBlue Airways
42 Southwest Airlines Co.
43 American Airlines Inc.
44 American Airlines Inc.
45 American Airlines Inc.
46 Skywest Airlines Inc.
47 Spirit Air Lines
48 American Airlines Inc.
49 Skywest Airlines Inc.
50 American Eagle Airlines Inc.
51 Skywest Airlines Inc.
52 American Airlines Inc.
53 Southwest Airlines Co.
54 JetBlue Airways
55 American Eagle Airlines Inc.
56 Delta Air Lines Inc.
57 American Airlines Inc.
58 Southwest Airlines Co.
59 American Airlines Inc.
60 Southwest Airlines Co.
61 Southwest Airlines Co.
62 Southwest Airlines Co.
63 American Eagle Airlines Inc.
64 JetBlue Airways
65 Southwest Airlines Co.
66 Southwest Airlines Co.
67 American Airlines Inc.
68 US Airways Inc.
69 American Airlines Inc.
70 Southwest Airlines Co.
71 Southwest Airlines Co.
72 Spirit Air Lines
73 JetBlue Airways
74 JetBlue Airways
75 Southwest Airlines Co.
76 JetBlue Airways
77 Skywest Airlines Inc.
78 Frontier Airlines Inc.
79 United Air Lines Inc.
80 Southwest Airlines Co.
81 American Airlines Inc.
82 JetBlue Airways
83 American Airlines Inc.
84 American Airlines Inc.
85 JetBlue Airways
86 Hawaiian Airlines Inc.
87 JetBlue Airways
88 Southwest Airlines Co.
89 JetBlue Airways
90 Southwest Airlines Co.
91 Skywest Airlines Inc.
92 Southwest Airlines Co.
93 JetBlue Airways
94 Skywest Airlines Inc.
95 Southwest Airlines Co.
96 Hawaiian Airlines Inc.
97 Southwest Airlines Co.
98 American Eagle Airlines Inc.
99 Frontier Airlines Inc.
100 Virgin America
101 Atlantic Southeast Airlines
102 Southwest Airlines Co.
103 Southwest Airlines Co.
104 Southwest Airlines Co.
105 Delta Air Lines Inc.
106 Southwest Airlines Co.
107 Southwest Airlines Co.
108 Delta Air Lines Inc.
109 United Air Lines Inc.
110 American Eagle Airlines Inc.
111 Skywest Airlines Inc.
112 Southwest Airlines Co.
113 Alaska Airlines Inc.
114 Delta Air Lines Inc.
115 American Airlines Inc.
116 Southwest Airlines Co.
117 Skywest Airlines Inc.
118 American Eagle Airlines Inc.
119 Skywest Airlines Inc.
120 American Eagle Airlines Inc.
121 Southwest Airlines Co.
122 Southwest Airlines Co.
123 United Air Lines Inc.
124 Southwest Airlines Co.
125 Skywest Airlines Inc.
126 Skywest Airlines Inc.
127 American Eagle Airlines Inc.
128 Skywest Airlines Inc.
129 Skywest Airlines Inc.
130 United Air Lines Inc.
131 Southwest Airlines Co.
132 JetBlue Airways
133 American Airlines Inc.
134 Skywest Airlines Inc.
135 Skywest Airlines Inc.
136 Southwest Airlines Co.
137 JetBlue Airways
138 Skywest Airlines Inc.
139 Virgin America
140 United Air Lines Inc.
141 Southwest Airlines Co.
142 United Air Lines Inc.
143 Skywest Airlines Inc.
144 Southwest Airlines Co.
145 Skywest Airlines Inc.
146 Skywest Airlines Inc.
147 Southwest Airlines Co.
148 JetBlue Airways
149 American Airlines Inc.
150 Skywest Airlines Inc.
151 JetBlue Airways
152 JetBlue Airways
153 Southwest Airlines Co.
154 Skywest Airlines Inc.
155 Delta Air Lines Inc.
156 JetBlue Airways
157 United Air Lines Inc.
158 Virgin America
159 JetBlue Airways
160 United Air Lines Inc.
161 Skywest Airlines Inc.
162 JetBlue Airways
163 American Airlines Inc.
164 Skywest Airlines Inc.
165 American Eagle Airlines Inc.
166 Southwest Airlines Co.
167 American Airlines Inc.
168 American Airlines Inc.
169 Southwest Airlines Co.
170 United Air Lines Inc.
171 American Airlines Inc.
172 Delta Air Lines Inc.
173 JetBlue Airways
174 JetBlue Airways
175 Skywest Airlines Inc.
176 Skywest Airlines Inc.
177 Delta Air Lines Inc.
178 Skywest Airlines Inc.
179 United Air Lines Inc.
180 Alaska Airlines Inc.
181 Virgin America
182 Delta Air Lines Inc.
183 United Air Lines Inc.
184 Skywest Airlines Inc.
185 Skywest Airlines Inc.
186 Southwest Airlines Co.
187 Virgin America
188 United Air Lines Inc.
189 JetBlue Airways
190 Southwest Airlines Co.
191 American Eagle Airlines Inc.
192 American Airlines Inc.
193 American Airlines Inc.
194 Alaska Airlines Inc.
195 Southwest Airlines Co.
196 American Eagle Airlines Inc.
197 Hawaiian Airlines Inc.
198 Skywest Airlines Inc.
199 Southwest Airlines Co.
200 American Eagle Airlines Inc.
201 JetBlue Airways
202 Southwest Airlines Co.
203 United Air Lines Inc.
204 Atlantic Southeast Airlines
205 Southwest Airlines Co.
206 Virgin America
207 Southwest Airlines Co.
208 American Airlines Inc.
209 Skywest Airlines Inc.
210 Delta Air Lines Inc.
211 JetBlue Airways
212 Skywest Airlines Inc.
213 JetBlue Airways
214 American Eagle Airlines Inc.
215 Skywest Airlines Inc.
216 Skywest Airlines Inc.
217 US Airways Inc.
218 American Airlines Inc.
219 Southwest Airlines Co.
220 Southwest Airlines Co.
221 United Air Lines Inc.
222 United Air Lines Inc.
223 American Eagle Airlines Inc.
224 United Air Lines Inc.
225 Southwest Airlines Co.
226 JetBlue Airways
227 United Air Lines Inc.
228 United Air Lines Inc.
229 Southwest Airlines Co.
230 American Eagle Airlines Inc.
231 American Airlines Inc.
232 Southwest Airlines Co.
233 United Air Lines Inc.
234 American Eagle Airlines Inc.
235 United Air Lines Inc.
236 Virgin America
237 Delta Air Lines Inc.
238 Virgin America
239 American Airlines Inc.
240 JetBlue Airways
241 Atlantic Southeast Airlines
242 Southwest Airlines Co.
243 United Air Lines Inc.
244 Skywest Airlines Inc.
245 Virgin America
246 Alaska Airlines Inc.
247 Skywest Airlines Inc.
248 Southwest Airlines Co.
249 Skywest Airlines Inc.
250 Southwest Airlines Co.
251 Skywest Airlines Inc.
252 JetBlue Airways
253 American Eagle Airlines Inc.
254 American Airlines Inc.
255 Frontier Airlines Inc.
256 Virgin America
257 United Air Lines Inc.
258 Delta Air Lines Inc.
259 Skywest Airlines Inc.
260 Skywest Airlines Inc.
261 JetBlue Airways
262 Alaska Airlines Inc.
263 US Airways Inc.
264 American Eagle Airlines Inc.
265 Skywest Airlines Inc.
266 Skywest Airlines Inc.
267 Southwest Airlines Co.
268 US Airways Inc.
269 American Eagle Airlines Inc.
270 United Air Lines Inc.
271 Alaska Airlines Inc.
272 United Air Lines Inc.
273 American Airlines Inc.
274 American Airlines Inc.
275 Southwest Airlines Co.
276 United Air Lines Inc.
277 JetBlue Airways
278 United Air Lines Inc.
279 American Eagle Airlines Inc.
280 US Airways Inc.
281 Delta Air Lines Inc.
282 Alaska Airlines Inc.
283 JetBlue Airways
284 Skywest Airlines Inc.
285 American Airlines Inc.
286 American Airlines Inc.
287 Southwest Airlines Co.
288 United Air Lines Inc.
289 JetBlue Airways
290 JetBlue Airways
291 United Air Lines Inc.
292 United Air Lines Inc.
293 Southwest Airlines Co.
294 JetBlue Airways
295 Southwest Airlines Co.
296 Alaska Airlines Inc.
297 JetBlue Airways
298 Delta Air Lines Inc.
299 American Airlines Inc.
300 Alaska Airlines Inc.
301 United Air Lines Inc.
302 Delta Air Lines Inc.
303 Delta Air Lines Inc.
304 Skywest Airlines Inc.
305 United Air Lines Inc.
306 JetBlue Airways
307 United Air Lines Inc.
308 Southwest Airlines Co.
309 American Airlines Inc.
310 Delta Air Lines Inc.
311 United Air Lines Inc.
312 Virgin America
313 US Airways Inc.
314 Alaska Airlines Inc.
315 Southwest Airlines Co.
316 JetBlue Airways
317 Southwest Airlines Co.
318 Alaska Airlines Inc.
319 Alaska Airlines Inc.
320 Delta Air Lines Inc.
321 Alaska Airlines Inc.
322 Alaska Airlines Inc.
323 Alaska Airlines Inc.
324 US Airways Inc.
325 Southwest Airlines Co.
326 Alaska Airlines Inc.
327 Virgin America
328 JetBlue Airways
329 Alaska Airlines Inc.
330 United Air Lines Inc.
331 Skywest Airlines Inc.
332 US Airways Inc.
333 American Airlines Inc.
334 Skywest Airlines Inc.
335 Alaska Airlines Inc.
336 Skywest Airlines Inc.
337 Delta Air Lines Inc.
338 Delta Air Lines Inc.
339 Delta Air Lines Inc.
340 JetBlue Airways
341 Alaska Airlines Inc.
342 American Eagle Airlines Inc.
343 US Airways Inc.
344 American Airlines Inc.
345 US Airways Inc.
346 Alaska Airlines Inc.
347 American Airlines Inc.
348 American Airlines Inc.
349 Virgin America
350 Southwest Airlines Co.
351 Skywest Airlines Inc.
352 Alaska Airlines Inc.
353 Alaska Airlines Inc.
354 Delta Air Lines Inc.
355 Alaska Airlines Inc.
356 Delta Air Lines Inc.
357 Alaska Airlines Inc.
358 Hawaiian Airlines Inc.
359 Alaska Airlines Inc.
360 Alaska Airlines Inc.
361 Virgin America
362 Delta Air Lines Inc.
363 Delta Air Lines Inc.
364 Skywest Airlines Inc.
365 American Airlines Inc.
366 United Air Lines Inc.
367 Delta Air Lines Inc.
368 Alaska Airlines Inc.
369 American Airlines Inc.
370 Alaska Airlines Inc.
371 Alaska Airlines Inc.
372 JetBlue Airways
373 Delta Air Lines Inc.
374 Delta Air Lines Inc.
375 American Eagle Airlines Inc.
376 Delta Air Lines Inc.
377 JetBlue Airways
378 JetBlue Airways
379 United Air Lines Inc.
380 Alaska Airlines Inc.
381 Alaska Airlines Inc.
382 Alaska Airlines Inc.
383 Alaska Airlines Inc.
384 Delta Air Lines Inc.
385 Alaska Airlines Inc.
386 Skywest Airlines Inc.
387 Delta Air Lines Inc.
388 Alaska Airlines Inc.
389 JetBlue Airways
390 Atlantic Southeast Airlines
391 Delta Air Lines Inc.
392 Alaska Airlines Inc.
393 Alaska Airlines Inc.
394 Delta Air Lines Inc.
395 Virgin America
396 JetBlue Airways
397 Frontier Airlines Inc.
398 United Air Lines Inc.
399 Delta Air Lines Inc.
400 Atlantic Southeast Airlines
401 Skywest Airlines Inc.
402 Skywest Airlines Inc.
403 United Air Lines Inc.
404 Alaska Airlines Inc.
405 Virgin America
406 Delta Air Lines Inc.
407 JetBlue Airways
408 JetBlue Airways
409 Delta Air Lines Inc.
410 Alaska Airlines Inc.
411 United Air Lines Inc.
412 Virgin America
413 Alaska Airlines Inc.
414 Alaska Airlines Inc.
415 US Airways Inc.
416 Alaska Airlines Inc.
417 Delta Air Lines Inc.
418 Alaska Airlines Inc.
419 Skywest Airlines Inc.
420 JetBlue Airways
421 US Airways Inc.
422 Alaska Airlines Inc.
423 American Eagle Airlines Inc.
424 Delta Air Lines Inc.
425 Virgin America
426 Alaska Airlines Inc.
427 Alaska Airlines Inc.
428 United Air Lines Inc.
429 Delta Air Lines Inc.
430 Skywest Airlines Inc.
431 Alaska Airlines Inc.
432 Delta Air Lines Inc.
433 United Air Lines Inc.
434 Alaska Airlines Inc.
435 Alaska Airlines Inc.
436 Atlantic Southeast Airlines
437 United Air Lines Inc.
438 US Airways Inc.
439 Delta Air Lines Inc.
440 Alaska Airlines Inc.
441 Alaska Airlines Inc.
442 Delta Air Lines Inc.
443 United Air Lines Inc.
444 Alaska Airlines Inc.
445 Alaska Airlines Inc.
446 Atlantic Southeast Airlines
447 Delta Air Lines Inc.
448 Delta Air Lines Inc.Finalização
# Desconecta do banco de dados
dbDisconnect(con)```